SELECT QUERY

---

MySQL - Select Query

The SQL SELECT command is used to fetch data from the MySQL database.

SYNTAX  

SELECT column1, column2, ...
FROM table_name;

--(*) is used to select all from the table

SELECT * FROM table_name;

As a result following table gets displayed :

Select StudentName from studentinfo;

-----RESULT------

-----------------
|  StudentName   |
-----------------
|Manjusha       |
|Noothan        | 
|Meherish       |
|Ajaashi        |
|Sahayana       |
|Sweekrutha     |
|Manju          |
|---------------|

Select * from Studentinfo;


--------RESULT---------

------------------------------------------
| StudentID | StudentName | StudentClass |
------------------------------------------
| 1         |Manjusha     |fifth         |
| 2         |Noothan      |sixth         |
| 3         |Meherish     |seventh       |
| 4         |Ajaashi      |eighth        |
| 5         |Sahayana     |ninth         |
| 6         |Sweekrutha   |tenth         |
| 7         |Manju        |tenth         |
------------------------------------------